Tabela PersonnelType

Definicja tabeli PersonnelType

Name

PersonnelType

Code

PersonnelType

Comment

 


Lista kolumn tabeli PersonnelType

Name

Code

PersonnelTypeID

PersonnelTypeID

Code

Code

FullName

FullName

ShortName

ShortName

Active

Active


Kolumna PersonnelTypeID tabeli PersonnelType

Definicja kolumny PersonnelTypeID tabeli PersonnelType

Name

PersonnelTypeID

Code

PersonnelTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Code tabeli PersonnelType

Definicja kolumny Code tabeli PersonnelType

Name

Code

Code

Code

Data Type

VARCHAR2(10)

Mandatory

No

Comment

 


Kolumna FullName tabeli PersonnelType

Definicja kolumny FullName tabeli PersonnelType

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna ShortName tabeli PersonnelType

Definicja kolumny ShortName tabeli PersonnelType

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(50)

Mandatory

No

Comment

 


Kolumna Active tabeli PersonnelType

Definicja kolumny Active tabeli PersonnelType

Name

Active

Code

Active

Data Type

NUMBER(3)

Mandatory

Yes

Comment

Aktywnosc rekordu


Lista kluczy tabeli PersonnelType

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PersonnelType

Definicja klucza Identifier_1 tabeli PersonnelType

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment